﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="chuzhi.aspx.cs" Inherits="test_Default2" %>

<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title>无标题页</title>
    <link href="../style.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <form id="form1" runat="server">
    <div class="header_back" style="width: 818px; height: 65px; padding-left: 5px; padding-top: 5px;">
        <table style="width: 100%;" class="font33" border="0px" cellpadding="0" cellspacing="0">
            <tr>
                <td style="height: 27px; text-align: left;" width="3%" colspan="2">
                    <asp:Label ID="Label3" runat="server" Height="24px" Text="选择机构：" Width="121px">
                    </asp:Label>
                    <asp:DropDownList ID="DropDownList1" runat="server" DataTextField="jigou" DataValueField="jigou"
                        AppendDataBoundItems="true" AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
                        <asp:ListItem Text="请选择"></asp:ListItem>
                    </asp:DropDownList>
                </td>
            </tr>
            <tr>
                <td colspan="2" style="margin-top: 2px;">
                    <asp:Label ID="Label1" runat="server" Height="24px" Text="用户名或姓名：" Width="121px"></asp:Label>
                    <asp:TextBox ID="TextBox2" runat="server" Width="160px"></asp:TextBox>
                    <asp:Button ID="Button1" runat="server" Text="查询" OnClick="Button1_Click" />
                </td>
            </tr>
        </table>
    </div>
    <table width="815px" border="0" cellspacing="0" class="font33" style="margin-top: 5px;" cellpadding="0" cellspacing="0">
        <tr>
            <td colspan="2" class="table_con">
                <asp:GridView ID="GridView1" runat="server" PageSize="12" AutoGenerateColumns="False"
                    OnRowDataBound="GridView1_RowDataBound" Width="810px" BorderStyle="None" CellPadding="0"
                    ForeColor="Black" GridLines="Vertical">
                    <Columns>
                        <asp:BoundField HeaderText="编号" />
                        <asp:TemplateField HeaderText="选择">
                            <ItemTemplate>
                                <asp:CheckBox ID="CheckBox1" runat="server" />
                            </ItemTemplate>
                        </asp:TemplateField>
                        <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" SortExpression="id" />
                        <asp:BoundField DataField="username" HeaderText="用户名" SortExpression="username" />
                        <asp:BoundField DataField="username1" HeaderText="姓名" SortExpression="username1" />
                        <asp:BoundField DataField="gzdw" HeaderText="工作单位" SortExpression="gzdw" />
                        <asp:BoundField DataField="chuzhi" HeaderText="储值金额" SortExpression="chuzhi" />
                        <asp:BoundField DataField="yingskf" HeaderText="应收课费" SortExpression="yingskf" />
                        <asp:BoundField DataField="yiskf" HeaderText="已收课费" SortExpression="yiskf" />
                        <asp:BoundField DataField="qskf" HeaderText="欠收课费" SortExpression="qskf" />
                    </Columns>
                    <HeaderStyle BackColor="#D9EDB2" Font-Bold="True" ForeColor="Black" Font-Underline="False" />
                </asp:GridView>
            </td>
        </tr>
        <tr>
            <td ><div style="width:300px;_width:300px;">
                <asp:CheckBox ID="CheckBox2" runat="server" OnCheckedChanged="CheckBox2_CheckedChanged"
                    Text="全选" AutoPostBack="True" /><asp:TextBox ID="TextBox1" runat="server" Width="99px"></asp:TextBox>
                <asp:Button ID="Button2" runat="server" Text="储值" OnClick="Button2_Click" />
                <asp:Label ID="Label2" runat="server" Text="状态" Width="80px"></asp:Label></div>
            </td>
            <td class="webdeyer" style="padding-left:5;">
                <webdiyer:AspNetPager ID="Pager" runat="server" CurrentPageButtonClass="" FirstPageText="首页"
                    LastPageText="尾页" NextPageText="下一页" PageSize="17" PrevPageText="上一页" LayoutType="Div"
                    InvalidPageIndexErrorMessage="抱歉,页码超出范围" CustomInfoHTML="页次:%CurrentPageIndex%/%PageCount% 共%RecordCount%条"
                    PageIndexOutOfRangeErrorMessage="抱歉,页码超出范围" ShowCustomInfoSection="Left" ShowPageIndexBox="Always"
                    TextAfterPageIndexBox="页" TextBeforePageIndexBox="转到第" AlwaysShow="true" HorizontalAlign="Right"
                    Direction="LeftToRight" CustomInfoTextAlign="left" ShowPageIndex="False" OnPageChanging="pager_PageChanging"
                    ShowMoreButtons="False" Width="510px" ShowNavigationToolTip="True" CustomInfoClass="PagerClassCss"
                    SubmitButtonClass="page_go" PageIndexBoxClass="txt_class" CssClass="page_a">
                </webdiyer:AspNetPager>
            </td>
        </tr>
        <tr>
            <td colspan="2">
                <%-- <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:gConnectionString %>"
                    SelectCommand="SELECT [id], [username], [username1], [gzdw], [chuzhi], [yingskf], [yiskf], [qskf] FROM [account]  WHERE [role] ='学员'">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="TextBox2" DefaultValue="<%=TextBox2.Text.Trim()%>"
                            Name="username" PropertyName="Text" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>--%>
            </td>
        </tr>
        <tr>
            <td colspan="2">
                <%--  <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:gConnectionString %>"
                    SelectCommand="SELECT DISTINCT [jigou] FROM [account] WHERE (([role] = @role1) OR ([role] = @role2))">
                    <SelectParameters>
                        <asp:Parameter DefaultValue="机构" Name="role1" Type="String" />
                        <asp:Parameter DefaultValue="管理员" Name="role2" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>--%>
            </td>
        </tr>
    </table>
    </form>
</body>
</html>
